package com.itheima.Mapper;

import com.itheima.Pojo.Teacher;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface TeacherMapper {
    /**
     * 根据用户名和密码查询员工信息
     */
    @Select("select teacher_id,teacher_number,password,name,gender from teacher where name = #{name} and password = #{password}")
    Teacher selectByUsernameAndPassword(Teacher teacher);

    @Select("select * from teacher")
    List<Teacher> selectAll();
}
